#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default Locking Cells

Thanks for the help.

"Gord Dibben" wrote:

If the workbook is digitally signed it will be trusted on all workstaions.

I don't work with signatures and servers so don't know if simply putting an
unsigned workbook in a trusted location will do the trick.

Others who deal with this issue regularly will be along to assist.


Gord


On Fri, 3 Oct 2008 08:38:01 -0700, Locked Cells
wrote:

Thanks for replying,

Well I'm using it the same way as the other member. To allow other ppl to
enter information without them deleting anything else.

So lowering security isnt applicable as it will be on other ppl workstations.

It will be on a server so after giving it a signature how do i make the
signature apply to the other workstations when they open it.

What about putting it in a trusted location, would that be a possiblity?

Thanks


"Gord Dibben" wrote:

Lower your Security level?

Or digitally sign the workbook/project so it becomes trusted and not disable
macros.


Gord Dibben MS Excel MVP

On Thu, 2 Oct 2008 05:21:01 -0700, Locked Cells <Locked
wrote:

Hi this is exactly what i've been trying to do and i've got it working great.

There is one problem though when the program starts i get a bar appear
"Security Warning, Macros have been disabled [options]".

If you dont click enable then none of the security/locked cells (i.e. the
macro) does run.

Is there any way to make the program start already enabled.

Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locking cells P. Zicari Excel Worksheet Functions 1 October 24th 07 11:42 PM
locking formula in cells in without locking whole sheet SuziQ Excel Discussion (Misc queries) 1 July 21st 06 03:58 PM
Locking Cells chefmike Excel Discussion (Misc queries) 6 March 15th 06 04:50 PM
locking cells denhar Excel Discussion (Misc queries) 3 June 16th 05 12:31 AM
Locking Cells WendiW Excel Discussion (Misc queries) 1 March 10th 05 08:15 PM


All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"