ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem with buttons (https://www.excelbanter.com/excel-discussion-misc-queries/52740-problem-buttons.html)

Cerise

Problem with buttons
 

Hi

I have 2 workbooks to which I'm adding a button with a small macro
attached (the same one on each).
Using the forms toolbar, I've added a button to one of the workbooks,
no problem.
The other is causing problems. When I open the forms toolbar it's all
greyed out. The worksheet isn't protected and even the cells are
unlocked. I'm at a loss to work out what the problem is.

Any ideas?

Many thanks


--
Cerise
------------------------------------------------------------------------
Cerise's Profile: http://www.hightechtalks.com/m157
View this thread: http://www.hightechtalks.com/t2272299


Jim Cone

Problem with buttons
 
Cerise,
It will do that if more than one sheet is selected.
Jim Cone
San Francisco, USA



"Cerise" wrote...
Hi
I have 2 workbooks to which I'm adding a button with a small macro
attached (the same one on each).
Using the forms toolbar, I've added a button to one of the workbooks,
no problem.
The other is causing problems. When I open the forms toolbar it's all
greyed out. The worksheet isn't protected and even the cells are
unlocked. I'm at a loss to work out what the problem is.
Any ideas?
Many thanks--
Cerise



All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com