how do i do this coding If a button is not available for the current user then the next buttons must cover its space automatically.
if i have 3 buttons, the middle one is not visible for current user, how do the next button cover its space??
what's the code to do this
So if you have 3 buttons (shapes) with names 1, 2 and 3,
Code:If SomeCondition = True Then Worksheets("SheetName").Shapes("1").Left = Worksheets("SheetName").Shapes("2").Left Worksheets("SheetName").Shapes("2").Visible = False Else Worksheets("SheetName").Shapes("1").Left = 10 ' Or whatever was the original left position Worksheets("SheetName").Shapes("2").Visible = True End If
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
erm, sorry what do i replace the SomeCondition with and must i replace the name SheetName to other thing??
what is the code to define WorkSheets, i tried googling but i can't find any except for macro stuff...
Last edited by Excel Fox; 02-02-2013 at 06:22 PM. Reason: Removed Quote
Some condition would be something like what you've mentioned in your original post.
The code would be something like
Code:If Environ("USERNAME")="ExcelFox" OR Environ("USERNAME") = "Jeffrey" Then '.....some code' Else '.....other code End If
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
what about the WorkSheets what codes to define it??
Last edited by Excel Fox; 02-02-2013 at 06:23 PM. Reason: Removed Quote
In VBA, one normally refers to a worksheet by the name 'Sheet 1' with the codeCode:Worksheets("Sheet 1")
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks