silly object question, Probably right in my face

[cizzett]

So I have a "Tool Bar" across the top of my worksheet that I want to remain the exact same size and position except when row 1 is hidden the tool bar should be hidden as well.

If I hide columns etc I don't want the tool bar to change size but I can only seem to get it to either not size or hide or hide and size.

Any guidance would be appreciated as always.

 

[Logit]

.
Not much to go on. If the "toolbar" is a UserForm you can hide the form.

 

[cizzett]

They are multiple buttons, checkboxes, and a couple textboxes. All grouped together

 

[Logit]

Where are these objects located ? In row one of the sheet ? Or somewhere else ?

It would be best if you could post your workbook (less and confidential information) to a cloud site so it can be downloaded and viewed.
DropBox.com, etc.

 

[cizzett]

Yep row one, I can post a screen shot in the morning when I fire up the laptop and a copy of the workbook once I pull a few items out of it

 

[Logit]

.
This is one method.

Place two ActiveX command buttons on the sheet, in row one. Each button is attached to one of these macros :

Option Explicit


Sub Shapes1() 'command button one calls this macro
    On Error Resume Next
    ActiveSheet.DrawingObjects.Visible = False
    ActiveSheet.Rows(1).Hidden = True
    On Error GoTo 0
    ActiveSheet.OLEObjects("CommandButton1").Visible = True
    ActiveSheet.OLEObjects("CommandButton2").Visible = True
End Sub


Sub Shapes2() 'command button two calls this macro
    On Error Resume Next
    ActiveSheet.DrawingObjects.Visible = True
    ActiveSheet.Rows(1).Hidden = False
    On Error GoTo 0
End Sub