MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ted Collins   on Feb 03 In MS Office Category.

Question Answered By: Sydney Thompson   on Feb 03

I take it you're familiar with VBA modules:

in a code module, paste:
Sub test()
MsgBox "Path: " & ActiveWorkbook.Path & _
Chr(13) & "Name: " & ActiveWorkbook.Name & _
Chr(13) & "FullName: " & ActiveWorkbook.FullName
End Sub

then execute it.

It will show you what Excel sees as the name and path of the active workbook.
to make "double-sure" you COULD even test the ActiveWorkbook.FullName
to make sure that it is Exactly the file you're expecting them to use.


if (ActiveWorkBook.FullName <> "P:\user name\FileName.xls") then
msgbox "Copies of this file are not allowed"
exit sub
end if



This Question has 27 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Restrict workbook to network Or get search suggestion and latest updates.