columns
 

hi,

i want to be able to hide and unhide columns in excel depending upon a value
selected and then veryfying whether or not a value entered is correct. but
the only disadvantage of this is that any user who does not enter the value
correctly can just go to the sheet and select column -- unhide. i want to
prevent this from happening.

what is the best way to handle this?

thanks in advance,
geebee

columns
 

One way might be to remove the row and column headers. Tools - Options -
View - uncheck Row & Column Headers.

This will make it distinctly more difficult to unhide the columns without
having to resort to some form of protection.
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

i want to be able to hide and unhide columns in excel depending upon a value
selected and then veryfying whether or not a value entered is correct. but
the only disadvantage of this is that any user who does not enter the value
correctly can just go to the sheet and select column -- unhide. i want to
prevent this from happening.

what is the best way to handle this?

thanks in advance,
geebee

columns
 

On 27 May, 16:33, geebee (noSPAMs) wrote:
*i want to
prevent this from happening.
what is the best way to handle this?

This may not be the _best_ way, but will work. Just turn off the menu
items.

Application.CommandBars("Worksheet Menu
Bar").Controls("Format").Controls("&Column").Contr ols("&Unhide").Enabled
= False
Application.CommandBars("Column").Controls("&Unhid e").Enabled = False

You might need to re-do the Column menu on the workbook_RightClick
event.

columns
 

hi,

i have the following:

If Sheets("detail").Range("IV1").Value = "admin" Then
Sheets("detail").Select
Columns("A").Visible = True
Else
Sheets("detail").Select
Columns("G").Visible = False
End If

but i am getting an "object does not support this method" error message. why?

thanks in advance,
geebee


"Jim Thomlinson" wrote:

One way might be to remove the row and column headers. Tools - Options -
View - uncheck Row & Column Headers.

This will make it distinctly more difficult to unhide the columns without
having to resort to some form of protection.
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

i want to be able to hide and unhide columns in excel depending upon a value
selected and then veryfying whether or not a value entered is correct. but
the only disadvantage of this is that any user who does not enter the value
correctly can just go to the sheet and select column -- unhide. i want to
prevent this from happening.

what is the best way to handle this?

thanks in advance,
geebee

columns
 

hi,

i am getting an "invalid procedure call or argument". on the following:

Application.CommandBars("Worksheet
MenuBar").Controls("Format").Controls("&Column").C ontrols("&Unhide").Enabled
= True


thanks in advance,
geebee


"atpgroups" wrote:

On 27 May, 16:33, geebee (noSPAMs) wrote:
i want to
prevent this from happening.
what is the best way to handle this?

This may not be the _best_ way, but will work. Just turn off the menu
items.

Application.CommandBars("Worksheet Menu
Bar").Controls("Format").Controls("&Column").Contr ols("&Unhide").Enabled
= False
Application.CommandBars("Column").Controls("&Unhid e").Enabled = False

You might need to re-do the Column menu on the workbook_RightClick
event.

columns
 

On 27 May, 20:05, geebee (noSPAMs) wrote:

i am getting an "invalid procedure call or argument". *on the following:

Application.CommandBars("Worksheet
MenuBar").Controls("Format").Controls("&Column").C ontrols("&Unhide").Enable d
= True

Is that space in the middle of"Enabled" really there? That will do
it.
Alternatively, find your own way to the menu item..
Select the words "Application.CommandBars" and then right-click and
"Add watch"
You will then see the tree of all the command bar properties, and you
can burrow on down the tree. I suspect that (for whatever reason) your
commandbars have different names