| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch to worksheet view
Hello -
I added a command button control to an Excel worksheet, went into the VBA editor and added the code. My problem is the only way I can run the control on the worksheet is to Save, Close Excel and re-open Excel, select the workbook and go to the specific worksheet. There has to be another way. Would someone explain how to shift views. Thanks, Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Switch to worksheet view
Perhaps you are in designe mode? When you draw a control on a worksheet, you
enter "design mode." Click the button with a triangle and ruler image to exit design mode. "Paul Breslin" wrote in message . .. Hello - I added a command button control to an Excel worksheet, went into the VBA editor and added the code. My problem is the only way I can run the control on the worksheet is to Save, Close Excel and re-open Excel, select the workbook and go to the specific worksheet. There has to be another way. Would someone explain how to shift views. Thanks, Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Switch to worksheet view
Yes, thank you - that worked like a charm.
Paul "Bob Kilmer" wrote in message ... Perhaps you are in designe mode? When you draw a control on a worksheet, you enter "design mode." Click the button with a triangle and ruler image to exit design mode. "Paul Breslin" wrote in message . .. Hello - I added a command button control to an Excel worksheet, went into the VBA editor and added the code. My problem is the only way I can run the control on the worksheet is to Save, Close Excel and re-open Excel, select the workbook and go to the specific worksheet. There has to be another way. Would someone explain how to shift views. Thanks, Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I switch from one worksheet to the next without using the . | Excel Worksheet Functions | |||
| Switch between worksheet tabs? | Excel Discussion (Misc queries) | |||
| How to view a custom view when the worksheet is protected? | Excel Worksheet Functions | |||
| VBA Code to switch view | Excel Programming | |||
| VBA Button to switch worksheet(s) | Excel Programming | |||
Hybrid Mode
