Excel Q

[SBuzzT]

I have a workbook with a sheet that company users need to be able to access for calculations. The problem is, I need the following to work:

I cannot change the security settings on all computers to allow macros to run.
I need to be able to open the workbook without a security prompt about macros.
I need to be able to close the file without a save changes prompts.

I have found information that I can enter inhto the VB code to close without changes, but I would have to change the security settings for all the users (which cannot be done).

Any ideas/ workarounds?

 

[SkipVought]

hi,

1 & 2 are not possible.

3 can be dome via VBA, using Application.DisplayAlerts = False

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnotherHiggins]

For 1&2, you could save the workbook as an Addin, then install the addin in each user's Excel. You can even have a single addin file on a network drive that all users are connected to.

That might or might not work depending on what you're trying to do.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SBuzzT]

That might work, but I need to be able to do this without affecting everyone excel install (from the file itself).

Any way to just prevent people from be able to save?

 

[AnotherHiggins]

Wait - you're just trying to send out a workbook and prevent users from saving changes?

Look at Excel's built in protection. Tools > Protection > Protect Workbook (or, if you're in 2007, Review > Changes > Protect Workbook).

Please just state what your goals are up front.


[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SBuzzT]

Let me clarify... I have some formulas and some responses that come up based on the input into a specific cell. Everything but that cell is protected (people need to be able to input a date) but the problem is, if anyone saves, it will save the date that the last person entered for the next person.

Any way to prevent this?

 

[AnotherHiggins]

What version of Excel are you running?

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SBuzzT]

2007

 

[Gavona]

Click the Microsoft Office Button , click Save As, and on the bottom of the Save As dialog, click Tools.
On the Tools menu, click General Options. The General Options dialog opens.
Under File sharing, in the Password to modify box, type a password.
In the Confirm Password dialog, re-type the password. Click OK.

Less secure options but helps to prevent accidental modification of a workbook:
In the above command string you can set a ReadOnlyRecommended rather than setting a password
OR
Set the Windows file property to read only

Gavin

 

[cheerio]

Consider storing the workbook as a template?