Please help

  • Thread starter Thread starter NFI
  • Start date Start date
N

NFI

Hi all,
Can anyone help me with these two problems?

1) I've got a cells in one workbook linked to cells in
another and every time I open it an alert is displayed
advising me of this and asking me if I want to update the
links or keep the current information.
Is there anyway of automatically updateing these linked
cells, an getting rid of the alert?

2) I have two cells which are updated with the date and
time respecively, by a button on the sheet.
The sheet they are on is protected when it's activated by
userinterfaceonly:= true
However, if I then deactivate the sheet and activate it
again, I get the run time error 1004 Method 'Portect' of
object '_worksheet' failed.
This also happens if I unprotect the sheet, update the
cells and protect it again.

Any help with either of these problems would be much
appreciated.
 
NFI wrote
Hi all,
Can anyone help me with these two problems?

1) I've got a cells in one workbook linked to cells in
another and every time I open it an alert is displayed
advising me of this and asking me if I want to update the
links or keep the current information.
Is there anyway of automatically updateing these linked
cells, an getting rid of the alert?
Click to expand...

In Excel 2002 (XP) there is an option on the Edit --> Links
dialog to set the prompt. Set it to update links without asking
the user. If you are using another version you may not be able
to set this but you can set it on version 2002 and then it works
on some other versions.


2) I have two cells which are updated with the date and
time respecively, by a button on the sheet.
The sheet they are on is protected when it's activated by
userinterfaceonly:= true
However, if I then deactivate the sheet and activate it
again, I get the run time error 1004 Method 'Portect' of
object '_worksheet' failed.
This also happens if I unprotect the sheet, update the
cells and protect it again.
Click to expand...



What I have worked out is that UserInterfaceOnly = TRUE
only works if you redo it every time you open the workbook
On the open method for the workbook you can add some code
to do this to all worksheets in that workbook.

Chrissy.
 
Back
Top