Hello All,
In Excel I have statement
Application.OnKey "^{BREAK}", "Sub_Trap_Break"
This is okay at all times when there is no Userform being displayed but when there is a form this does not work.
Any ideas how to overcome this
I am trying to stop users get to the spreadsheet.
To stop this I have:
1) Form event Query Close
2) The sheet only becomes visible when macros are enabled otherwise it is xlVeryHidden
3) The cells font and background colours are the same so nothing can be seen ! and it is protected at the appropriate times
4) Menus are disabled
But that fact that on control Break (when a form is displayed) the VBE window appears is irritatting, any ideas (No code is displayed as that is protected too!)
Thanks for any ideas
Chas
PS This is only a temporary measure whilst I wait for Access to be installed on my PC at work, (probably will end up being my 2007 New Year's present from the Administrators!)
Control Break Trap will not work whilst Userform is displayed
Gravy
Hi Chas,
I'm doing very well thanks...
I've created a small example approach you can use until you get Access. The approach I've used uses an Excel Addin to insert data into a backend and shared (I think) spreadsheet. I've done it in such a way that when you get Access there will be very little to do to update the backend.
post your email address and I'll send it on along with a better explaination.
Ad Hoc
Derek,
How are you .
I knew I could count on you for an explanation!
Thanks again.
I might wait to get Access and start writing it in that.
Thanks again
Chas
Nick Sheng
dbro101
p.s. the reason your Application.OnKey isn't working for Userforms is because the OnKey event is only been handled for key presses when Excels main window (the application) has focus. Once the focus switches to a Userform any key presses on the form are not handled at the Excel's application level but are instead handled within the user form.
César Santos
Hello Derek,
That will be great thanks.
My email is charleschand@aol.com
Regards
Chas
poodle
Hi Chas,
How about creating an Excel addin
Excel Addins are like hidden spreadsheets where you can store code and access cells etc but all in a fairly hidden way. The macros of the workbook would be available through toolbars or menu items while the sheets of the addin sit hidden in the background. If you password protect the addin there isn't an easy way to display the sheets.