FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Can't view VBA project when moved from Windows

 
   Mac (Home) -> Mac Word RSS
Related Topics:
Page view - What would cause pages to be invisible after page breaks in the normal view, but in the Page view? Pidge

endnotes for each chapter moved to end of book - i have just written a book using WORD 2004 with nine chapters and put the endnotes at the back of each i need to place them all at the end of the total document still arranged by chapters and numbered to beging with 1 for the NOTES section..

Word 2004 notebook view hung... help recover file? - Hello! I am a student, use an iBook G4, 14" screen, 1.33GHz, with 768M of RAM. I am using OS 10.4.2 and Word 2004 version 11.1 (040910). I take notes in class on my iBook using notebook view because of its ability to record the lecture as I type; tha

Windows fonts - I installed Microsoft Office 2004 and a number of Windows fonts were thrown into my folder. I would like to get rid of these fonts. Are any of them necessary for Word, or Excell? And if so, will an Open Type or Mac font..

The mystery of disappearing windows - I am having a very annoying behaviour on MS Word lately. As I am working, all of a sudden the window I am working on closes. It is still in the Window menu and check marked as if it is the currently active window. To get back to it, I select another..
Next:  Mac Word: Tables & Borders Toolbar not visible  
Author Message
Gary Hillerson

External


Since: Jan 28, 2006
Posts: 10



(Msg. 1) Posted: Mon Mar 13, 2006 9:25 am
Post subject: Can't view VBA project when moved from Windows
Archived from groups: microsoft>public>mac>office>word (more info?)

I'm hitting a strange problem. I've got a large project that I'm
porting from Office on Windows to Office on Mac OSX.

On Windows, I open the project in the VBE, then tell it to remove
protection, so it'll be viewable without a password. If I close Word,
reopen that file, and go back into VBE, I can view the macros just
fine.

I move the file across my network to my Mac. Open it, and try to
access the macros in VBE on the Mac, and I get a Project locked for
Viewing message. Furthermore, there's no opportunity to enter a
password and view the project.

Can anyone help with this. I'm trying to debug on the mac, and can't
get to my macros to see what's going on.

Thanks in advance,
gary hillerson
Back to top
Login to vote
Beth Rosengard

External


Since: Aug 08, 2005
Posts: 175



(Msg. 2) Posted: Mon Mar 13, 2006 1:02 pm
Post subject: Re: Can't view VBA project when moved from Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Gary,

This may be way off track since I know nothing about VBE issues, but try
this: Navigate to the file in the Finder, select it and do a Get Info
(Cmd-i). In the Ownership & Permissions section, make sure you have Read &
Write selected.

--
***Please always reply to the newsgroup!***

Beth Rosengard
MacOffice MVP

Mac Word FAQ: <http://word.mvps.org/Mac/WordMacHome.html>
Entourage Help Page: <http://www.entourage.mvps.org>



On 3/13/06 9:25 AM, in article unab12d7fihi7ocou4letgu5jb0gg0nt7a DeleteThis @4ax.com,
"Gary Hillerson" <garyh DeleteThis @hillysun.net> wrote:

> I'm hitting a strange problem. I've got a large project that I'm
> porting from Office on Windows to Office on Mac OSX.
>
> On Windows, I open the project in the VBE, then tell it to remove
> protection, so it'll be viewable without a password. If I close Word,
> reopen that file, and go back into VBE, I can view the macros just
> fine.
>
> I move the file across my network to my Mac. Open it, and try to
> access the macros in VBE on the Mac, and I get a Project locked for
> Viewing message. Furthermore, there's no opportunity to enter a
> password and view the project.
>
> Can anyone help with this. I'm trying to debug on the mac, and can't
> get to my macros to see what's going on.
>
> Thanks in advance,
> gary hillerson
Back to top
Login to vote
John McGhie [MVP - Word a

External


Since: Sep 11, 2006
Posts: 357



(Msg. 3) Posted: Tue Mar 14, 2006 9:28 am
Post subject: Re: Can't view VBA project when moved from Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Gary:

Sorry, the Mac VBE can't handle projects that are or ever were protected in
any way. It detects the digital signature, but since it can't handle it it
falls through to a catch-all that simply disables the project.

You need to take it across to the Mac as text and re-create the project
there.

I strongly suggest that you port that project to AppleScript on the Mac.
You will find that Mac Word VBA is simply not up to the task. Ping me
offline if you need more...

Cheers


On 14/3/06 4:25 AM, in article unab12d7fihi7ocou4letgu5jb0gg0nt7a.DeleteThis@4ax.com,
"Gary Hillerson" <garyh.DeleteThis@hillysun.net> wrote:

> I'm hitting a strange problem. I've got a large project that I'm
> porting from Office on Windows to Office on Mac OSX.
>
> On Windows, I open the project in the VBE, then tell it to remove
> protection, so it'll be viewable without a password. If I close Word,
> reopen that file, and go back into VBE, I can view the macros just
> fine.
>
> I move the file across my network to my Mac. Open it, and try to
> access the macros in VBE on the Mac, and I get a Project locked for
> Viewing message. Furthermore, there's no opportunity to enter a
> password and view the project.
>
> Can anyone help with this. I'm trying to debug on the mac, and can't
> get to my macros to see what's going on.
>
> Thanks in advance,
> gary hillerson

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <john.DeleteThis@mcghie.name>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410
Back to top
Login to vote
Gary Hillerson

External


Since: Jan 28, 2006
Posts: 10



(Msg. 4) Posted: Tue Mar 14, 2006 9:28 am
Post subject: Re: Can't view VBA project when moved from Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

It's well beyond porting to AppleScript -- a very, very large piece of
code that's taken many years to evolve into its current state. I
simply haven't the time to port it, since the main customer base is on
the PC. I'm trying to make it available on the Mac, but don't have the
resources required to put a ton of effort into that.

The worst part is that it almost works fine. Most of it works fine.
But when I hit a little hitch, i pretty much have to work on the code
on my PC, and test on the Mac. VBE on the Mac sucks!

So, if i'm reading you correctly, I can on my PC export all of the
userforms and modules (about 100 in all), create a new, unprotected
project, import them all into that project, and then copy that over to
the Mac. I'll try that in a few minutes.

thanks,
g

On Tue, 14 Mar 2006 09:28:14 +1100, "John McGhie [MVP - Word and Word
Macintosh]" <john.RemoveThis@mcghie.name> wrote:

>Hi Gary:
>
>Sorry, the Mac VBE can't handle projects that are or ever were protected in
>any way. It detects the digital signature, but since it can't handle it it
>falls through to a catch-all that simply disables the project.
>
>You need to take it across to the Mac as text and re-create the project
>there.
>
>I strongly suggest that you port that project to AppleScript on the Mac.
>You will find that Mac Word VBA is simply not up to the task. Ping me
>offline if you need more...
>
>Cheers
>
>
>On 14/3/06 4:25 AM, in article unab12d7fihi7ocou4letgu5jb0gg0nt7a.RemoveThis@4ax.com,
>"Gary Hillerson" <garyh.RemoveThis@hillysun.net> wrote:
>
>> I'm hitting a strange problem. I've got a large project that I'm
>> porting from Office on Windows to Office on Mac OSX.
>>
>> On Windows, I open the project in the VBE, then tell it to remove
>> protection, so it'll be viewable without a password. If I close Word,
>> reopen that file, and go back into VBE, I can view the macros just
>> fine.
>>
>> I move the file across my network to my Mac. Open it, and try to
>> access the macros in VBE on the Mac, and I get a Project locked for
>> Viewing message. Furthermore, there's no opportunity to enter a
>> password and view the project.
>>
>> Can anyone help with this. I'm trying to debug on the mac, and can't
>> get to my macros to see what's going on.
>>
>> Thanks in advance,
>> gary hillerson
Back to top
Login to vote
Display posts from previous:   
       Mac (Home) -> Mac Word All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
Categories:
 Windows Forums
 Game Forums
 Linux Forums
  Mac Forums
 PDA Forums
 Mobile Forums
  Top  |  Store  |  RSS Feeds RSS  |  Data Feeds  |  Advertise  |  Submit  |  Bookmark  |  Newsletter  |  Contact