Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save without Macros without prompting
I have a template that runs some code, populates a sheet then saves it.
If I specify the extension .xlsx then it prompts about saving without VBA Project, this is what I want to do (the VBA would be redundant on a sheet that's already filled in now). Is there a way of suppressing the confirmation dialogue? ISTR some code for removing the VBA project but I also remember that last time I tried that it gave me jip about trying to access the VBA project, which was untrusted or something like that. -- Travis Crow |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save without Macros without prompting
Hi Travis
Chip Pearson has a great code for removing VB Projects / Modules, you name it... I use it at work and it works very well..... http://www.cpearson.com/Excel/vbe.aspx Just remember to make sure this has a tick: Macro Security | Trust access to the VBA Project Object Model. Else the code will not not work.... HTH Mick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop prompting for save the changes in Excel | Excel Discussion (Misc queries) | |||
Prompting 'Save As' in an Excel Macro | Excel Programming | |||
Save CSV File without prompting | Excel Programming | |||
Save file without prompting | Excel Programming | |||
Excel not prompting to save Add-ins | Excel Programming |