Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do you enbed a marcos or VB in a sheet?
The subject is the question
Thanks Mike |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do you enbed a marcos or VB in a sheet?
Hi Mike,
Right click on the sheet tab with the sheet name on it. Select View Code. This opens the VBA editor where you can insert code for the specific sheet. Normally you place event driven code here. When you first open the vba editor before any code is placed here, at the top of the large white area you will see 2 drop down boxes. One with the default General and the other with default Declarations. If you click the arrow of the one with General, you can select worksheet. You can then click the arrow of the other box and you will get a list of all the events. Clicking on them will create a Private Sub name and End sub for the particular event. -- Regards, OssieMac "Mike Stewart" wrote: The subject is the question Thanks Mike |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do you enbed a marcos or VB in a sheet?
Right click the sheet tap and select view code after pasting / writing the
code you can close. To run this macro go to tools macrorun macro (Alt=F8) you can give a name to this recorded macro for security reasons in the drop down list (macros in) select current workbook) and click run. -- Thanks Suleman Peerzade "Mike Stewart" wrote: The subject is the question Thanks Mike |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do you enbed a marcos or VB in a sheet?
Ok thanks this helped
Thanks: Oissemac and Suleman Mike "Mike Stewart" wrote: The subject is the question Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete old Marcos | Excel Discussion (Misc queries) | |||
using marcos to copy large amounts of info | Excel Discussion (Misc queries) | |||
were can i find stuff on writting marcos | Excel Discussion (Misc queries) | |||
How to convert Grid to Chart with Marcos Automatically? | Charts and Charting in Excel | |||
Marcos | Excel Worksheet Functions |