ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Command Button Shades annoying (https://www.excelbanter.com/excel-worksheet-functions/194855-command-button-shades-annoying.html)

Mikey

Command Button Shades annoying
 
HI
I have a workbook that I created with 8 sheets. I Have 8 command buttons
across the top. When clicking through these some of the previous buttons are
left with a diagonal shading. Sometimes to get rid of these I need to click
away.

I am running Excell 2003

Can anyone help


ryguy7272

Command Button Shades annoying
 
Im not really sure what you are referring to here, but if you right-click
those control Buttons, and then click €˜Properties, you will see three
options:
Move and size with cells
Move but dont size with cells
Dont move or size with cells

Choose the appropriate option for your specific needs; try each and see what
kinds of difference it makes as you are building sheets with your macro€¦


Regards,
Ryan---


--
RyGuy


"MIKEY" wrote:

HI
I have a workbook that I created with 8 sheets. I Have 8 command buttons
across the top. When clicking through these some of the previous buttons are
left with a diagonal shading. Sometimes to get rid of these I need to click
away.

I am running Excell 2003

Can anyone help



All times are GMT +1. The time now is 07:13 AM.

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