gibbo1715
02-12-2005, 02:23 AM
Dont know if this exists so just checking
I have a userform running and have hidden excel behind it and password protected my code
I have also coded the userform so when unloaded it closes the workbook and hides (xlVeryHidden) the worksheets protecting my data.( so done all the security stuff as best I can within excel i think). Work book is also password protected ( well excel passwords anyway)
What i want to know is is there a short cut available to my users that will stop the VBA running and close the userform without running the close macro attached to it, giving access to the worksheets that would normally be hidden
And if so can I de activate the short cut?
I know this can be done using another workbook anyway but thats not an issue for me
I have a userform running and have hidden excel behind it and password protected my code
I have also coded the userform so when unloaded it closes the workbook and hides (xlVeryHidden) the worksheets protecting my data.( so done all the security stuff as best I can within excel i think). Work book is also password protected ( well excel passwords anyway)
What i want to know is is there a short cut available to my users that will stop the VBA running and close the userform without running the close macro attached to it, giving access to the worksheets that would normally be hidden
And if so can I de activate the short cut?
I know this can be done using another workbook anyway but thats not an issue for me