Results 1 to 1 of 1
2002-01-31, 01:13 #1
- Join Date
- Jan 2002
- Brisbane, Australia
- Thanked 0 Times in 0 Posts
Excel Macro Vulnerability Patch breaks AutoFormat (MS Office 9.0.3821 SR-1
I would be most grateful if somebody could confirm or disprove my observation below:
applying the <A target="_blank" HREF=http://(http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin/ms01-050.asp>Excel Macro Vulnerabilty Patch</A> breaks the VBA method AutoFormat in Excel. Instead of applying the selected "Theme", it destroys all formatting information in the selection.
Omitting the Format parameter will not select the default Classic1 as the documentation suggests, instead it will select Simple. Anything else will behave as above: destroying all format information.
This just cost me two full days of debugging. I proved my conclusion by uninstalling MS Office (9.0.3821 SR-1 under NT5.00.2195 SP2), installing it again, testing VBA AutoFormat: it worked. Installing the patch mentioned above: it ceased to work.
Now: how do I uninstall the patch without uninstalling MS Office? Or is there another work-around to achieve AutoFormat with a format other than Simple?
Can anybody confirm this? The simplest way would be this:
- <LI>Create a small table, say 3 by 3, with some formatting somewhere
<LI>Select the nine cells
<LI>Turn Macro Recorder on
<LI>Apply Autoformat / Classic1 to that table
<LI>Stop Macro Recorder
<LI>Run the previously recorded macro