I have a workbook which is networked. Im trying to include a macro that
will automatically run when the workbook is opened in read/write format
but will not run when its read only.
I understand macro's but aint got a clue on how to do this if it can be
done. If it can could I poss have a idiot proof guide.
Many Thanks
--
tweacle
at the top menu beside File, there is an excel symbol, right click on that icon and select view codes,
Now at the drop down menu where it says general, drop down the menu to select -workbook
go to the next drop down menu and select -open
beginning and ending code appears
copy and paste your macro between these two lines of code
for example purposes
copy and paste this code in between those two lines
Dim Msg As String
Msg = "This is Dave's great WorkBook!!"
MsgBox Msg
it will end up looking like this
Private Sub Workbook_Open()
Dim Msg As String
Msg = "This is Dave's great WorkBook!!"
MsgBox Msg
End Sub
Once you have that right then practise butting in the code from your macro
After you find out where this code goes, check out Dave Peterson's reply
Dave
Last edited by davesexcel; 02-25-2006 at 02:46 PM.
You could add a single line to the top of your procedure:
Option Explicit
Sub auto_open()
If ThisWorkbook.ReadOnly Then Exit Sub
'your normal code here
End Sub
(or workbook_open if you used that)
tweacle wrote:
>
> I have a workbook which is networked. Im trying to include a macro that
> will automatically run when the workbook is opened in read/write format
> but will not run when its read only.
>
> I understand macro's but aint got a clue on how to do this if it can be
> done. If it can could I poss have a idiot proof guide.
>
> Many Thanks
>
> --
> tweacle
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks