I've been working on a workbook with macros that needs to be sent to users who might not know how to get past the macros prompts. The data entry is by user form but is there a way to save it so when the recipient opens the WB they don't have to mess with prompts?
Peace of mind is found in some of the strangest places.
Code it without prompts?
Hi Austen
If you're talking about macro security then you'll need a digital signature.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Hi md,
long time huh? Anyway if i create a DS it needs to be able to be ran on windows 7 and 10. any thoughts.
Peace of mind is found in some of the strangest places.
I've always used SelfCert.exe. It does require the Users' PC to be set to trust the certificate but once done you should avoid the prompts. A quick read seems to show other newer methods but I've never used them.
Happened across this which may assist.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote
