T
Travis Crow
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.
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.