This is great, but to work on the document, you will need to switch to editing mode.So whenever you open a file that originated from a website or that you received via email, you are taken to Protected View.
These sources include a website, email attachments, and other unsafe locations such as shared drives. Next, choose the Trust Center category and then click the Trust Center Settings button. You can disable all three if you do not want Protected View to intervene at all in the future. This is very common when working with Excel on mobile devices and accessing documents when in public locations. Fortunately, Microsoft makes it relatively easy to switch into Editing Mode. On most days, he can be found teaching Excel in a classroom or seminar. ![]() Since we launched in 2006, our articles have been read more than 1 billion times. So I recreated it on a PC, and am now unable to open it on a Mac (it opens but error messages read Method or data member not found and Run-time error 1004: reference not valid (Microsoft Visual Basic) ). Any ideas I read that performing a save as in the non-host program would work, however that didnt work. The macros are pretty simple (sort, find, filter functions) however there are about 70 or 80 of them. Hopefully they all arent in 1 module anyway, try exporting the code into.bas files (done in the vbe) and removing them from the current workbook. ![]() I dont have a Mac so this is just something to try. Regards, Tom Ogilvy marika1981 wrote in message news:872F6B2F-A65E-47F5-BFAE-F03B8DF9F907microsoft.com. I created a heavy-formatted, macro-intensive spreadsheet (5 or 6 megs) on a Mac and was unable to open it on a PC - it crashed Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |