Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Catch Excel Open Workbook Event
- Thread starter ninjamyst
- Start date
TonyJollans
Programmer
Hi ninjamyst,
You can assign your own code to run in response to toolbar buttons (via the OnAction Property). I'm not entirely sure how many places you'll need to change - you'll need to do a FindControl or similar to identify them. Also you'll need to reassign hotkeys like Ctrl+O (via Application.OnKey) and exactly what else depends a litle on exactly what you want to achieve.
Enjoy,
Tony
--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[
You can assign your own code to run in response to toolbar buttons (via the OnAction Property). I'm not entirely sure how many places you'll need to change - you'll need to do a FindControl or similar to identify them. Also you'll need to reassign hotkeys like Ctrl+O (via Application.OnKey) and exactly what else depends a litle on exactly what you want to achieve.
Enjoy,
Tony
--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Solved