Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with macros in Excel 2007
If the worksheet name changed after the macro was created, the macro still
worked. I don't believe this. The macro would be hard coded with something like Sheets("My Sheet").Activate and changing the sheet name would produce an error in this command. This is true in Excel 2007 or any previous version. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Michelle" wrote in message ... I have had an enquiry from a user. In Excel 2003 she could create and run a macro that included going to a specific worksheet. If the worksheet name changed after the macro was created, the macro still worked. In Excel 2007, if the worksheet name is changed after the macro is created, the macro does not work? Any suggestions? -- Michelle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros for Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 and Macros | Excel Discussion (Misc queries) | |||
Macros in Excel 2007 | Excel Discussion (Misc queries) |