Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |