View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neeraja Neeraja is offline
external usenet poster
 
Posts: 5
Default Make one column Invisible.

Hi,

Could someone let me know if it is possible to make a
Column in Excel sheet Invisible by VBA Programming.
I need to Hide a Column which contains Data which is
useful for my Programming but not required to be viewed
by the User.

If i hide the column by, for e.g:

Range("N1").Value = "SKU Number"
Columns("N:N").Hidden = True

and then insert the required data into this, the user may
by mistake unhide it or possibly overwrite it somehow. I
dont what this to happen.

Its like i want to make the column invisible and somehow
lock it so that the user will not be able to unhide it.
how do i go about with this???
Thanks in Advance for any help.

Regards,
Neeraja.