Make one column Invisible.
You could put it outside the normal viewing area and set the scrollarea
"Neeraja" wrote in message
...
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.
|