AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Disable macros in excel 973/19/2024 ![]() Here is another way to do this using VBA only: This can be done straight after creating the macro, as it will still run when hidden. To hide the macro sheet ( just for tidyness ), simply choose menu commmand Format/Sheet/Hide. This macro will only run once, at the next time the workbook is opened. which will show the "Define Name" dialog box, with a guess of name of Auto_Open ( which is a reserved name in Excel, in that it runs automatically when the workbook is opened ), and then choose the Command option in the Macro section. Now, make cell A1 the active cell, and use menu command Insert/Name/Define. ![]() ![]() In cell A2: =ALERT("Text of all the reminders",3) Insert an Excel macro sheet by right clicking any sheet tab, and choosing Insert from the pop-up menu, and choosing a sheet type of MS Excel 4.0 Macro. Well, I remember how to do it in Excel 4 macros, if that's any help.
0 Comments
Read More
Leave a Reply. |