Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Disable the msgboxes macro and links when open an excel file
- Thread starter francky
- Start date
[color]francky[/color]:
Disable Macro Message Box
The Macro Virus Protection feature in Microsoft Excel is designed to warn you when the workbook you are opening contains macro code. When you receive the warning, you can enable or disable the code. The only way to prevent this is to change the security level for macro virus protection
[ol][li]In the Tools menu, point to Macro, and then click Security.[/li][li]Click the Security Level tab, and then click the option you want.[/li][/ol]This will only affect the computer(s) where the security level is changed.
Disable Automatic Links Message Box
I am not aware of any way to disable this message box except to remove the links between files. Personally, I never link between workbook files since too many problems can occur if one of the files is lost or deleted.
Regards, LoNeRaVeR
Disable Macro Message Box
The Macro Virus Protection feature in Microsoft Excel is designed to warn you when the workbook you are opening contains macro code. When you receive the warning, you can enable or disable the code. The only way to prevent this is to change the security level for macro virus protection
[ol][li]In the Tools menu, point to Macro, and then click Security.[/li][li]Click the Security Level tab, and then click the option you want.[/li][/ol]This will only affect the computer(s) where the security level is changed.
Disable Automatic Links Message Box
I am not aware of any way to disable this message box except to remove the links between files. Personally, I never link between workbook files since too many problems can occur if one of the files is lost or deleted.
Regards, LoNeRaVeR
to disable a link in VBA when opening, use the updatelinks command after the workbooks open, for example see below.
Workbooks.Open Filename:=pathname, updatelinks:=3
0 Doesn't update any references
1 Updates external references but not remote references
2 Updates remote references but not external references
3 Updates both remote and external
for no updating and disbale you would use 0.
hope it helps.
Workbooks.Open Filename:=pathname, updatelinks:=3
0 Doesn't update any references
1 Updates external references but not remote references
2 Updates remote references but not external references
3 Updates both remote and external
for no updating and disbale you would use 0.
hope it helps.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Helpful tip
