Deny access to a masked column

jiugiusto · 01-10-2006, 01:31 PM

Hi,

How can I deny access to a masked column.

Thanx

**Glaswegian** · 01-10-2006, 02:19 PM

Hi

A wee bit more information would help.

What application? What do you mean by masked?

The more details you provide, the more likely it is you will receive a useful reply.

jiugiusto · 01-10-2006, 02:45 PM

Hi and thanx for the reply.

Application: Ms Excel
I created a small excel file where I can calculate some prices.
In this file, the units cost are shown in a column.

I need to mask that specific column (which can be done by right clicking on the column and mask);
But I need as well to deny access to that column so that the user of the file cannot right click, show back the column and see the units price.

Pls advise.

Thanx.

**Glaswegian** · 01-10-2006, 03:12 PM

Hi

The easiest way is to hide your column then protect the sheet - Tools > Protection > Protect Sheet. You can select various protection options and ensure that users cannot delete columns.

HTH

Regards

jiugiusto · 01-10-2006, 04:06 PM

Hi,

Let me thank you for the bright idea you game me.
I tried it on my laptop and It did the job. I need to apply it on the file which I have on my desktop; i think it should work as well.

Thanx

**Glaswegian** · 01-10-2006, 04:07 PM

You are welcome!

01-10-2006, 01:31 PM	#1 (permalink)
jiugiusto Registered User Join Date: Nov 2004 Posts: 9 OS: Winxp pro	Deny access to a masked column Hi, How can I deny access to a masked column. Thanx

01-10-2006, 02:19 PM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,460 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Hi A wee bit more information would help. What application? What do you mean by masked? The more details you provide, the more likely it is you will receive a useful reply. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

01-10-2006, 03:12 PM	#4 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,460 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Hi The easiest way is to hide your column then protect the sheet - Tools > Protection > Protect Sheet. You can select various protection options and ensure that users cannot delete columns. HTH Regards __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

01-10-2006, 04:07 PM	#6 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,460 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	You are welcome! __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

01-10-2006, 02:45 PM	#3 (permalink)
jiugiusto Registered User Join Date: Nov 2004 Posts: 9 OS: Winxp pro	Hi and thanx for the reply. Application: Ms Excel I created a small excel file where I can calculate some prices. In this file, the units cost are shown in a column. I need to mask that specific column (which can be done by right clicking on the column and mask); But I need as well to deny access to that column so that the user of the file cannot right click, show back the column and see the units price. Pls advise. Thanx.

01-10-2006, 04:06 PM	#5 (permalink)
jiugiusto Registered User Join Date: Nov 2004 Posts: 9 OS: Winxp pro	Hi, Let me thank you for the bright idea you game me. I tried it on my laptop and It did the job. I need to apply it on the file which I have on my desktop; i think it should work as well. Thanx