• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

Is it possible to secure a single page within an Excel sheet

Hi All,

can I secure a single sheet (page2) in one Excel file?

Thankx
0
Agrippa
Asked:
Agrippa
  • 5
  • 4
  • 3
  • +1
4 Solutions
 
Brian GeeCommented:
Would going to Tools > Protection > Protect Sheet fit this criteria? In the same area is Protect Workbook, but you would not opt for that.
0
 
jppintoCommented:
What do you mean by "secure"? Freeze?

Select the cell from where you want to freeze and on the View tab, click "Freeze Panes" and select "Freeze Panes" option.

0
 
Brian GeeCommented:
^ Excel 2003

Excel 2010:

Review tab > Protect Sheet button under the Changes section.
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
Chris BottomleyCommented:
Single page ... no protection is by sheet or workbook and that is the only scope.

Chris
0
 
jppintoCommented:
If you want to protect a Sheet/Workbook, then take a look at the attached image.

jppinto
Capture.JPG
0
 
AgrippaSenior IT ConsultantAuthor Commented:
Hi JppInto,

has nothing to do with freezing, actually securing, so page 1 is accessible and page 2 requires password.
0
 
AgrippaSenior IT ConsultantAuthor Commented:
Hi All,

not protecting for changes, but for access, because someone needs to access page 1, but has no rights to access page 2 (so it would popup for a password).
0
 
Brian GeeCommented:
Use the Protect Sheet option I mentioned.

If you have Sheet1 open and there are Page Breaks, you are off to a start. Select All of Sheet1 and go to Format Cells > Protection tab > uncheck Locked.

Then select all of Page2 on Sheet1 and then go to Format Cells > Protection tab > check Locked.

Then apply Protect Sheet protection to this worksheet with a password and then edits to Page2 cannot be done but surrounding pages can still accept text, etc.
0
 
Brian GeeCommented:
Just saw your reply above, n/m my above reply then...
0
 
Chris BottomleyCommented:
No as I said earlier you cannot protect a page withing a sheet ... just a sheet as a whole or a workbook as a whole .... can you move the first page onto a sheet of it's own and then protect what's left of the old sheet with a password

Chris
0
 
AgrippaSenior IT ConsultantAuthor Commented:
Hi Yobri,

the page2 must not be visable at all, so also no read rights. I think Chris is right and I have to move it to a separate file. Right Chris?
0
 
Brian GeeCommented:
^ That would be the optimal means, yes. But to do what you want (not visible on only a certain section/page), I think VBA would need to be involved in some capacity.

<<Just saw your reply above, n/m my above reply then...>>

I replied the above quote after having submitted my reply and then saw you indicated not visible...
0
 
Chris BottomleyCommented:
Not necessarily a seperate file but a seperate tab BUT ....

Note for excel sheet security should generally as good enough to stop the casual reader but not enough to make the data SECURE in the strict interpretation.

i.e. with 2003 and older the security is pretty easy to bypass , still possible with later versions but the difficulty cranks up.

So only include info that is critical for operation but not sensitive and use sheet hide to make it not obvious ... can use very hidden to mean it is harder to pick up FOR the CASUAL user.

Hopefully you get the idea re security here ;o)

Chris
0
 
AgrippaSenior IT ConsultantAuthor Commented:
Ok, so it is not a "one click" build in solution within Excel. So I made 2 seperate files.

Thankx for the feedback, good to know how this works.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 5
  • 4
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now