In Excel 2003 can you password protect a single page in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a business budget in excel, and want to link to a
confidential payroll page. Is there a way to link to a payroll projection
page in the same excel spreadsheet, and password protect a single page so
that the viewer is not able to view the specific contents of the payroll
page?
 
maybe you should try to hide sheet with payrolle information and use
tools-protection-protect workbook
 
Nope.

If you want to put confidential information in excel, don't share it with
others. Excel's protection isn't made to protect this kind of information.
 
What do you consider as a "page"?

Generally a page is a printed section of a worksheet.

Do you mean "worksheet" maybe?

You can hide a single worksheet by Format>Sheet>Hide.

Then you would Tools>Protection>Protect Wokbook.......structure and windows.

Enter a password and OK

BUT..........Excel's internal protection is very weak and passwords can be
easily cracked by users who can access the internet and search for "password
crackers".

You might get a little more protection from prying eyes if you use VBA code to
make a sheet xlveryhidden but not much.

The rule of thumb is..............if it is confidential material, leave it out
of the workbook.


Gord Dibben MS Excel MVP

On Sat, 22 Jul 2006 10:53:03 -0700, R Shields <R
 
Back
Top