New to all this - Problem

  • Thread starter Thread starter chimp
  • Start date Start date
C

chimp

I am setting up a workbook, that on the 1st sheet i want to become a
menu effectivly.

on this sheet i want to put a series of buttons, which when clicked run
a specific macro.

how can i do this please....

just after the code to put behind the button.

so if my macro is called 'sheet2'

what do i type

cheers

Andy
 
Hi,

Here is one way:

- rightclick the menubar, choose forms.
- A toolbar will appear.
- click the button with the button on it and draw a button
on your sheet
- rightclick that button, choose assign macro.
- Point to the appropriate macro and OK.
- Done.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Hi Thanks,

The trouble i now have is that when i click on the button, i get a new
message box appear saying that......macros are disabled in this
project.

Sorry to be a pain but how do i overcome this please
 
Hi Thanks,

The trouble i now have is that when i click on the button, i get a new
message box appear saying that......macros are disabled in this
project.

Sorry to be a pain but how do i overcome this please
 
Hi Thanks,

The trouble i now have is that when i click on the button, i get a new
message box appear saying that......macros are disabled in this
project.

Sorry to be a pain but how do i overcome this please
 
Sounds like you will have to enable macros - Try Tools / Options / Security Tab / Macro Security
button / Choose Medium.
 
Hi chimp,
The trouble i now have is that when i click on the button, i get a new
message box appear saying that......macros are disabled in this
project.
Click to expand...

Save the workbook, close it and open it again. You will be prompted to
enable macros. DO that.

Regards,

Jan Karel Pieterse
Excel MVP
 
Back
Top