Search results for query: *

Good morning, I have a problem figuring out a bit of code for a button on a user form. The button works exactly as I want it to but I need to put a password on the button. Basically I have a spreadsheet for budgeting. Part of this requires users to input payroll details for every member of...

Yesterday I posted this question and got answers to solve my problem but...... I've stopped working on the file and it still opens up (the file is closed) after the predetermined time (20 minutes) I used : application.ontime now + 20 minutes "myprocedure" (this is short hand for what I...

I'm sure i seen this tip somewhere but can't find it. I want to select cells on a workbook that are highlighted yellow so i can unprotect them, as they will be input cells. How do i do this? thanks

Good afternoon. I need a macro that will save a file every 20 minutes without relying on the autosave feature. I have a save macro. How do I make this run every 20 minutes? As always thanks,for reading this and any help will be gratefully accepted.

I have a spreadsheet that uses imported data of variable length (always the same width though). The data normally goes from cell A2 to R3000 (somethimes greater than 3000, somethimes less. In cell s2 I have a formula. I want to copy this formula to s3,s4 etc all the way down to s3000 (or...

I have a spreadsheet that uses imported data of variable length (always the same width though). The data normally goes from cell A2 to R3000 (somethimes greater than 3000, somethimes less. In cell s2 I have a formula. I want to copy this formula to s3,s4 etc all the way down to s3000 (or...

Hello All - first post so please be gentle if I'm not clear enough on question. I have a macro that runs from a fix file. (Users have identical files but may have different names for them). The basic idea is they have their file open and then open the Fix File. An automatic macro then goes to...