| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Msg. when file has no macros
I used a tab naming macro written in "Mymacrofile" to name tabs on "NEWFILE."
When I open NEWFILE, I get a message saying file may contain macros. Why is this? When I open the Macro window in the Tools menu, there are no macros there. Please help me understand this. I specificially did not want the NEWFILE to have macros, because I don't want the users to see that macro message when they open the file. Thanks so much |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro Msg. when file has no macros
See http://www.contextures.com/xlfaqMac.html#NoMacros
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Stilla" wrote in message ... I used a tab naming macro written in "Mymacrofile" to name tabs on "NEWFILE." When I open NEWFILE, I get a message saying file may contain macros. Why is this? When I open the Macro window in the Tools menu, there are no macros there. Please help me understand this. I specificially did not want the NEWFILE to have macros, because I don't want the users to see that macro message when they open the file. Thanks so much |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro Msg. when file has no macros
Thank YOU SO MUCH!!! I had one module, deleted it, and now it opens fine.
"Bob Phillips" wrote: See http://www.contextures.com/xlfaqMac.html#NoMacros -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Stilla" wrote in message ... I used a tab naming macro written in "Mymacrofile" to name tabs on "NEWFILE." When I open NEWFILE, I get a message saying file may contain macros. Why is this? When I open the Macro window in the Tools menu, there are no macros there. Please help me understand this. I specificially did not want the NEWFILE to have macros, because I don't want the users to see that macro message when they open the file. Thanks so much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Prompt for File -- Neophite Needs HELP | Excel Discussion (Misc queries) | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| I moved a file from work to home and now my color macro does not w | Excel Worksheet Functions | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| file folder macro's | Links and Linking in Excel | |||
Hybrid Mode
