ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Macro Msg. when file has no macros (https://www.excelbanter.com/excel-worksheet-functions/70613-macro-msg-when-file-has-no-macros.html)

Stilla

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

Bob Phillips

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




Stilla

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






All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com