I would suggest that if you need to do this, the code should be in a normal module and visible to both the sheet's button and the ThisWorkbook code. If you do wish to do it using Run the syntax is
assuming that sheet1 is the code name of the relevant sheet.
application.run "sheet1.commandbutton1_click"
Don
Please remember to mark your thread 'Solved' when appropriate.
I would have thought that if the sub "Commandbutton_click" is a public sub in a normal module, you can call it from any worksheet or other module by just Commandbutton_click and not have to do the Application.run with the sheet1 qualifier.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks