Hiding a Macro Button

[ParanoidAndroid]

Hi Mr Excel

I want to hide a macro button in a certain condition..

I'm pretty sure my problem is the apostrophies ' ' within the inverted commas " " that exist before around the .xls part 'Internal Account.xls'!send_To_Account_Opening

How do i fix this?

Help most appreciated

If Range("D9") = Sheets("Sheet1").Range("B75") then
    Sheets("Application Form").Shapes("'Internal Account.xls'!send_To_Account_Opening").Hide
  Else
    Sheets("Application Form").Shapes("'Internal Account Application Form.xls'!send_To_Account_Opening").Visible
  End If

 

[Sthrncali]

Hi Mr Excel

I want to hide a macro button in a certain condition..

I'm pretty sure my problem is the apostrophies ' ' within the inverted commas " " that exist before around the .xls part 'Internal Account.xls'!send_To_Account_Opening

How do i fix this?

Help most appreciated

If Range("D9") = Sheets("Sheet1").Range("B75") then
    Sheets("Application Form").Shapes("'Internal Account.xls'!send_To_Account_Opening").Hide
  Else
    Sheets("Application Form").Shapes("'Internal Account Application Form.xls'!send_To_Account_Opening").Visible
  End If

Is this really the shape name?

("'Internal Account.xls'!send_To_Account_Opening").

It looks more like the macro address than the shape name...
Here is a reference for you to demonstrate the proper syntax. Just make sure your shape name resides inside the parenthesis.

Sheet1.Shapes("myShape").Visible = msoTrue
Sheet1.Shapes("myShape").Visible = msoFalse

 

[ParanoidAndroid]

Hi Sthrncali

I dont know...I just right clicked on the macro button and selected assign macro and used what was written in the box..

How do I find the name of the button i have assigned to the macro?

 

[asking]

Right click on the macro button and the name of the button will show in the name box ~ Which is at the top and left of the formula bar.

Unless you have given the button a name it will be Button 1, Button 2 or Button X (another number)