I am using 2010 Excel on a 64-bit W7 computer. I have been programming for many years, but am just starting to use VBA in Excel. My marco works correctly, but when I close my spreadsheet, it disables the macro and I had to start over again. I have created a digital signature and saved spreadsheet as a macro-enabled spreadsheet. I am lost as to what I am doing wrong.
JWML
What are your security settings? Sounds as though all macros are disabled without asking for confirmation.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Macro Setting is Disable all macros except digitally sign macros.
JWML
I suggest you change it to ask for confirmation.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
JWML 
Register To Reply
Bookmarks