New to all this - Problem

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
 
J

Jan Karel Pieterse

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
 
C

chimp

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
 
C

chimp

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
 
C

chimp

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
 
K

Ken Wright

Sounds like you will have to enable macros - Try Tools / Options / Security Tab / Macro Security
button / Choose Medium.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



Paul Falla said:
Sub ButtonForSheet2 ()
Sheets("Sheet2").Select
End Sub
-----Original Message-----
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



------------------------------------------------
[/url]
~~ View and post usenet messages directly from http://www.ExcelForum.com/

.
Click to expand...
Click to expand...
 
J

Jan Karel Pieterse

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
 
Top