toggle button size modified via vba

[sassriverrat]

I'm 99% you can't make a toggle button using code, so can you change the size and location of one via code?

I have a few on a sheet and they seem to have resized/relocated on their own when switch computers and it's quite annoying so I was just going to have code (if possible) to ensure they don't do that again.

Thanks!

 

[My Aswer Is This]

So why not use a On Open script:

In The Vba editor double click on Thisworkbook

And paste in this code:

Private Sub Workbook_Open()
Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"", False)"
End Sub

 

[sassriverrat]

So why not use a On Open script:

In The Vba editor double click on Thisworkbook

And paste in this code:

Private Sub Workbook_Open()
Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"", False)"
End Sub

That was my first thought but when I tried it, it ended up applying to any activeworkbook which was a problem

 

[My Aswer Is This]

This script will only work on the Workbook you put this script in.

 

[sassriverrat]

This script will only work on the Workbook you put this script in.

Except that (at least with excel 2010) two different workbooks share the same excel window....so you are endlessly switching from one to the other- it's not like opening, say, a second word document or google chrome window where it can be moved independent of the first....

 

[sassriverrat]

So really I should be tweaking this code for for differentiating between Excel 2013 and beyond versus some of the older machines running 2010

 

[My Aswer Is This]

I really do not have a answer.

I have never tried to have several workbooks open at the same time and have both of them visible and then tried to switch back from one to the other and try to do what your wanting.

​