You would have to add it to your QAT, Bernard. It can be found in the
"Commands not in the Ribbon" section, under Excel Options, Customize.
Thanks.
--
Jim
|I would be happy to report this but I am dense this morning. Please tell me
| where to find the Toggle Read Only button.
| best wishes
| --
| Bernard V Liengme
| Microsoft Excel MVP
|
http://people.stfx.ca/bliengme
| remove caps from email
|
| | > Like Hector I was able to reproduce the bug. I'm astounded MS phone
| > support
| > directed you here to announce the bug or whatever. Must be someone new.
| >
| > Bernard, can you notify the MS folks supporting the private MVP
newsgroup
| > about this? It should be addresses in Excel 14 if not in the next
Service
| > Patch.
| >
| > --
| > Jim
| > | > | Bernard,
| > |
| > | I understand what you telling me, but the situation I'm trying to
| > explain
| > is
| > | a bit different.
| > |
| > | I know that having a "Password to Modify" and no "Password to open"
| > allows
| > | the ability to save off the file as a copy then edit it. That's not
the
| > | problem.
| > |
| > | The result we are trying to acheive is to prevent edits to the
workbook
| > in
| > | question, but still allow read-only ability. The function works fine
| > until
| > | someone uses the "Toggle Read Only" button. And when they do, the
| > password
| > | originally set in THAT workbook somehow is no longer there. And that
| > user
| > can
| > | make changes to THAT workbook. Someone, it stripped away the password,
| > and
| > | from that point forward, the workbook will no longer prompt for a
| > "password
| > | to modify" anymore.
| > |
| > | Little confusing if you haven't seen it. Let me know how I can explain
| > it
| > | more clearly or demostrate some how.
| > |
| > | -Ray
| > |
| > |
| > | "Bernard Liengme" wrote:
| > |
| > | > Not a bug but the norm for Excel (not just 2007)
| > | > If there is no open password and only a modify one, the users can
open
| > and
| > | > modify the workbook but must save it with a DIFFERENT name
| > | > So the ORIGINAL file is never altered unless the appropriate
password
| > is
| > | > used to open it with edit on
| > | > best wishes
| > | > (I have double checked this by doing an experiment)
| > | > --
| > | > Bernard V Liengme
| > | > Microsoft Excel MVP
| > | >
http://people.stfx.ca/bliengme
| > | > remove caps from email
| > | >
| > | > | > | > >I was directed here by Microsoft Phone support to post my excel
2007
| > BUG.
| > | > >
| > | > > We have users who save excel 2007 files using the "required
password
| > to
| > | > > modify" option, to prevent anyone from editing the files without a
| > | > > password.
| > | > >
| > | > > The BUG is when another user opens the file in "READ-ONLY" mode
who
| > | > > doesn't
| > | > > know the password, tries to toggle to edit mode, the user DOESN'T
| > get
| > | > > prompted for a password and can modify the excel 2007 file freely
| > and
| > | > > save.
| > | > >
| > | > > From there, when you go to re-open the same file, it no longer
asks
| > for a
| > | > > password to modify. THIS IS A HUGE SECURITY ISSUE IN EXCEL 2007
| > FILES.
| > | > >
| > | > > Is this a bug or am I just crazy?
| > | >
| > | >
| > | >
| >
|
|
