LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 144
Default Issue with command button visibility

Hi all - I'm reposting a question as I had not received a response. Just
wondering if anyone can help. Thx!

------------------
Hi all,

I have a command button where I'm setting .visible = false -- the problem is
that the button is still visible, even though the visible property was set to
false. It becomes invisible only after I enter design mode and then exit out
of design mode - then the .visible = false property kicks in. Any ideas why?
Thanks ahead of time. Below is from my code -- there is other code around
this but I don't think it would affect this issue (pasting all the code would
be a lot to go through). I thought the issue might have to do with how I set
Application.ScreenUpdating = True and then False in the middle of the sub (at
the beginning of the sub it is set to False and at the very end it is set
back to True), but when I commented this out, I still had the issue.


'Update sheet so user can see records highlighted in bold
Application.ScreenUpdating = True
Application.ScreenUpdating = False
'Run modules to update the Payment Master sheet
Module11.perfadvidassign
Module11.untiedpaysales
'Update 'Main Menu' so that "red" button is hidden
With Sheets("Performics Invoices not tied")
If .Range("A65536").End(xlUp).Address() = .Range("A1").Address()
Then
With Sheets("Main Menu")
'Change Font of cell to white
With .Range("C9").Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 2
End With
Sheets("Main Menu").Activate
With ActiveSheet.Shapes("perfopeninvoices")
.Visible = False
End With
With ActiveSheet.Shapes("perfpayin")
.Top = 225
.Left = 246
End With
End With
Else
End If
End With
Sheets("Performics Invoices not tied").Activate

'Show message box notifying the user that the records have been
submitted
MsgBox "Selected Invoices (those in bold) have been tied out"

--
Robert



--
Robert
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with Command Bar Button issue ?? Dan Thompson Excel Programming 3 October 20th 04 12:08 AM
Visibility of a command Button Al Bundy Excel Programming 2 May 7th 04 10:59 PM
Visibility of a command Button Bob Phillips[_6_] Excel Programming 1 May 7th 04 10:46 PM
Visibility of a command Button Jake Marx[_3_] Excel Programming 0 May 7th 04 10:28 PM
Command Button Visibility Problem Ian[_9_] Excel Programming 2 February 20th 04 06:51 PM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"