Doug McNutt wrote:
I have managed to move my finance workbook from a CY 2001 version of
Excel to libre-office-calc.
I had a lot to learn and I'm still frustrated when I want to insert a
few lines of entries from the bank. It's a pain having to do a separate
entry of the number of lines and then paste in contents. But..
Every time I start up the workbook I get a complaint that I'm using
macros and references to another file which is probably where I stored
macro-like commands that I wrote for Excel on the Mac. They used the
Macintosh Programmer's Workshop, MPW, development tools.
I'd like to get rid of the mouse and keystrokes required to startup. I
just say "no" to both but there must be a better way. For those
references there is probably a reference in the 20 worksheets but Mr.
Calc isn't telling me where they are.
Depending how the data is linked, Edit > Links... might help.
As for the macros I'd like to
discard them and rewrite those I really need using your command
structure. But where are they so I can killem?
Is the document saved as .ods or .xls? Saving as .ods might get rid of
the Excel macros. If that doesn't help, try Tools > Macros > Organise
Macros > LibreOffice Basic > Organiser...; see of there's anything under
the spreadsheet in any of the tabs there.
--
Mark.
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
