hi NoSparks,
See the attached.
If my original request is looking like it's going to be a ton of work, or just not possible, then would it be possible to stop the UserForm initializing if it 'saw' that the file type that was trying to opened was .xlsm? Initialize the UserForm if .xltm - don't initialize the UserForm if .xlsm?
Note that all the sheets are currently 'protected' and the current password is 'A'.
Many thanks
Mike
|