I go through the usual steps that i've always done in previous versions of word. when i try to use the macro nothing happens. i've gone into the trust center and ********** "enable all macros". nothing seems to work. what gives???
SOURCE: Office 2007 Standard - VBA not working
There is no indication that VBA should not work in all versions of Excel. There is a new file extension (xlsm), which is used to activate macros and allow usage. If you have, perhaps, opened and saved with incorrect extension (new is xlsx), VBA may be unavailable. Try to resave it with the changed extension. It seems likely that this is the issue (reference http://office.microsoft.com/en-us/excel/HP100141031033.aspx?pid=CH100648071033). Also, if you make sure your Save As option is set at xlsm, this should help to prevent problems. VBA should not be an issue in any version of Excel and custom functions ARE available (see http://office.microsoft.com/en-us/excel/HA102189961033.aspx?pid=CH100645021033). It should be as simple as changing the extension, and I would suggest changing the default save as option. If this helps, please rate "FixYa"! Thanks!
SOURCE: i am using microsoft excel
From the excel help file
377 views
Usually answered in minutes!
as i said, i've gone thru the steps you indicate and i create new macros and save them. but, when i go to use the macros there are not there to use.
i have no problem going through the steps to create and save a new macro. i just can't figure out why they disappear or should i say they never appear.
×