I have made a macro that does a "copy paste" action. Because the "copy" is on a formula cell, the macro has to do a "paste special" function to just put the numeric value into the new cell. This works fine until I "lock" the sheet.
It then tells me that the file is "locked" and stops the script...
I'm using Approach to print out a sales invoice on a laser printer. I have the form to print out the front of the paper, but I want to print some legalese, using a second form, on the back side. I am using a printer that will print on both sides of a sheet of paper. Has anyone tried to do this...
I have a Lotus 123 spreadsheet on a Windows network. Many different people use this sheet for doing finance calculations. When they are done using the spreadsheet, they click on a macro that resets all the changeable cells to a preset value , and then exits the program. If someone is using that...
I have a Lotus Aproach database that I would like to be able to print certain fields on a preprinted form. I have used trial and error methods creating a form and then arranging the fields. I have used up umteen preprinted forms trying to get it just right. Is there a more elegant way to this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.