Search results for query: *

Thanks for the advice. I ran out of time on this and came up with a solution. Basically I set the code on the button to open another form. This other form was simply a box to key a password. Hidden in the workbook I had already inserted the same word. After keying the password a bit of code...

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...

I've used the following. Will it work? Private Sub Workbook_BeforeClose(Cancel as Boolean) application.ontime "" End Sub Thanks

Sorry Skip. I'm struggling with this. I can't find workbook_close event. Where would it be?

Skip Thanks for that. Can I write a code to stop this application when I close the workbook? If so, how? Thanks again.

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...

xlbo worked perfectly. This is actually a very good little bit of code that will save me hours. Thanks

They're highlighted yellow by using the cell fil on tool bar

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

I've run the procedure manually a few time and all of a sudden it's started to work. Thnaks for the help - much appreciated.

I've manually checked that the procedure works by running the macro for timelimit. It works. Thanks

Hi PHV. Yes I have a procedure called "timetosave" I need the timelimit procedure to run by itself, after the defined time limit (15 secs) No crash or anything dramtic - it just didn't run the procedure after 15 seconds. Thanks

Hi Skip - thanks for the tip. I tried the following. Please note that I've not attempted to get anmything like this running before so mistakes are likely. Sub timelimit() Application.OnTime Now + TimeValue("00:00:15"), "timetosave" End Sub I put 15 secs in just to test it but it didn't work...

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.

Thanks very much - I used a bit of a combination and it works perfectly - the the following: Range("S2:W2").Select Selection.Copy LastRow = Range("A" & ActiveSheet.Rows.Count).End(xlUp).Row Range("S2:S" & LastRow).Select ActiveSheet.Paste End Sub

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...

moved over to the forum suggested - sorry for any inconvenience. Thanks

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...

Excellent Skip - very much appreciated. The Pesonal Workbbok name comes up first but I think I can eliminate this. Thanks a lot R

Sheet 1 of Fix workbook That means the auto macro can run and log the workbboks open. Noone can then tell me they only have one file open if more than one workbook is noted. I could also then use the file name from A1 (assuming that is where it puts their file name) instead of using...