Macro button help.

de8212

Board Regular
Joined
Apr 30, 2002
Messages
78
I need to assign a macro to a button. Problem is I can't make a button.
All ther "Forms" are greyed out so I can't select them.

THis is Office 2003 I am working with BTW.

After I get the button made I need to copy this workbook over the network to a different machine. I do not want the Error/Warning box to appear that say Enable/Disable Macros, etc. Isn't there someway to tell the pc to accept any excel files that contain macros that I create without prompting?
I know there's a way to set the security level to Low but I would rather not do that. I see where it lists Trusted Publishers but I don't know how to add myself to it?
THanks
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
59,079
Office Version
  1. 365
Platform
  1. Windows
Looks like you got a few questions working here:

Regarding creating a button
If you Right Click in the menu area, and select Forms, are they ALL greyed out, or just some of them?
Is your worksheet protected?

Regarding the Macro Warning Box
You can digitally sign your macros. Then, once a workstation accepts your signature as a "Trusted Source", it will no longer ask for confirmation on any worksbooks with macros signed by you. Check out this link for details:
http://www.mrexcel.com/board2/viewtopic.php?t=114736&highlight=digital+signature
 

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
If any of the cells in your worksheet is in EDIT mode, then many of the icons will be greyed out. So check whether any cell is in the EDIT mode.
You can also make use of AUTOSHAPES to assign a macro.
You cannot lower thesecurity level of a machine through code, (or it is believed so).
 

de8212

Board Regular
Joined
Apr 30, 2002
Messages
78
You were correct jm14. My sheet was locked.

Now on to the digital signature thing. I'll read over that link and hopefully be able to get it working properly.

Thanks.
 

Forum statistics

Threads
1,141,734
Messages
5,708,157
Members
421,549
Latest member
Dtcfire

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top