Jack Gillis <j2gil <at> widomaker.com> writes: > > I need help with this macro. Its purpose is to cycle through all the sheets > in the workbook, protect all the cells in the sheet, protect the sheet and > return to the original active cell. > > Here I can't figure out what statements are required to protect all the > cells in the sheet. Will someone 'please give me a clue. I've searched > Andrew Pitonyak's and the OOo Forums but have not been able to 'find an > answer. > > It would also help if in addition to the missing code above, Someone could > tell me how to get the name of the current active sheet. That is for > another project. > > Thank you very much. > Don't know how to do the protection except that perhaps you need to use createCursor to identify the cells you want to protect. The property for a sheet name is ".Name" - it's a string, of course. I've managed to get a lot of help by using the Xray tool. The version I have is from "XrayTool40_en.sxw" but there may be a newer version. "Danny's Basic Library" has also been helpful and I've even made some use of the SDK. I got these and other material either from OpenOffice.org or from http://api.openoffice.org/ I've also got the file "BasicMacroRecorder_2003-12-16.sxc" which installs macros to record, in Basic, commands affecting a single cell - that would give you the terminology. Cheers, Terry North.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
