$$Excel-Macros$$ Re: Hide Formula or data in column

2009-01-13 Thread Maddy
You can apply the background color of the cell (white in general) to the font color and check the hide option from Format > Cells > Protection tab. Now, if you protect the sheet, no one can see those data... Will this work for you? Maddy... On Jan 6, 1:38 pm, "Keyur Shah" wrote: > thanks for

$$Excel-Macros$$ Re: Hide Formula or data in column

2009-01-06 Thread Keyur Shah
thanks for response But did not want to hide entire column i want to hide only data enter in the column. Coulm should be visible but data entered in that column should not be visible to everyone. On Tue, Jan 6, 2009 at 12:33 PM, vijender kumar wrote: > Hi ... > > you can hide the column in very

$$Excel-Macros$$ Re: Hide Formula or data in column

2009-01-06 Thread vijender kumar
Hi ... you can hide the column in very simple way Select the column > Right Click with your Mouse > click on Hide On 1/5/09, Keyur Shah wrote: > > hi, > > Can anybody guide me how to hide data in column sothat no one can visible > and i want to lock sheet that mouse pointer move only selected

$$Excel-Macros$$ Re: Hide Formula or data in column

2009-01-05 Thread Sanjaykumar Bhola
Hi Keyur, Yes, you can select the column which you want to hide and to go to Format Menu --> Column --> Hide. On Mon, Jan 5, 2009 at 4:56 PM, Keyur Shah wrote: > hi, > > Can anybody guide me how to hide data in column sothat no one can visible > and i want to lock sheet that mouse pointer m