Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbar with macro
Greetings. I have a question. I email out a daily report that I have a
simple macro I run when I need to delete yesterday's information to make room for today's information. The people I send this too have asked that I take out the macro because of the warning message they get about macros and security. Is there a way I can creat a toolbar with my macro on, but it will not be embedded in the worksheet? I want to have the macro so I can run it, but when I email my report out, I do not want a macro to be embedded in the sheet. Thanks for all the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbar with macro
The simplest might be to save you macro in the Personal.xls - a hidden
workbook that is opended with Excel. You can apply it to another open workbook - just make sure the references are correct. You might find using the macro recorder a simple means of creating the right code. -- Cheers Nigel "coal_miner" wrote in message ... Greetings. I have a question. I email out a daily report that I have a simple macro I run when I need to delete yesterday's information to make room for today's information. The people I send this too have asked that I take out the macro because of the warning message they get about macros and security. Is there a way I can creat a toolbar with my macro on, but it will not be embedded in the worksheet? I want to have the macro so I can run it, but when I email my report out, I do not want a macro to be embedded in the sheet. Thanks for all the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a macro to a toolbar | Excel Discussion (Misc queries) | |||
TOOLBAR FOR A MACRO | Excel Discussion (Misc queries) | |||
macro in toolbar | Excel Discussion (Misc queries) | |||
macro toolbar | Excel Discussion (Misc queries) | |||
Macro Help on Toolbar | Excel Programming |