Search results for query: *

Skip, Yes thanks for your usual precision in pointing that out. I was less than explicit in my haste to post before leaving the office. Is this a well-known 'feature'? As I said in my original post we've only just today had Office 2007 installed (as a replacemet for 2003). I could't find any...

... Futhermore if you save a 2007 spreadsheet with all your code temporarily commented out say , when you return you will find it gone. Not only does the project protection fail silently but all your code is wiped too. Done and done for the day. TGIF.

Hah!! In 2003 one can set the project protection no problem and this then denies access to the code and also denies access to the sheets properties. Marvellous. In 2007 one can also set the project protection no problem, however I have discovered that it [silently] only 'takes' the setting if...

I have just had Office 2007 installed and am wondering if protection arrangements have changed in Excel2007 (vs 2003). I set the 'protect project from viewing' to yes and add a password and save. Then when I reopen the spreadsheet and select view code I expect to be asked for a password, yet I...

I have imported what is effectively a duplicate set of tables etc. from one db to another. All the imported objects (where duplicate names) are suffixed with a 1 as expected. How can I delete all tables whose names end in a 1, via code. Thanks for looking.

I have the following data: A1:Limit B1:Time c1:Value D1:Factor A2:5:51 4:07 46 0 4:22 66 1 A4:total 4:37 86 1 A5: ?370 4:52 103 1 5:07 115 1 5:22 124 0 5:37 131 0 5:52 135 1 6:07 137 1 6:22 138 1...

I think the simple limit is 7 nested IFs. You can see a possible solution to this though at this link http://www.cpearson.com/Excel/nested.htm Hope this helps.

That'll do nicely thanks, Skip*. Cheers, Steve.

I have written some data into say Cell AA12 now I want to write to AB12. How do I code this move to the next column? (I write to the first cell correctly becuase I have previously stored its location (ActiveCell) whilst I fetch the result from a sheet elsewhere; the second write will also get...

Skip, Add patience to that nuance! * Thanks to all for your help. Took a while to get there, but I think I've learned more in the process. Thanks again.

Skip, EXECUTE as in : I click on a button on sheet Wk0 to jump to the calc sheet and have a msgbox confirm the value of Sourcesheet (Wk0), before I actually jump. The value doesn't get transfered/ become available upon arrival at the calc sheet.

SkipVought Q."Where did you assign the Sourcesheet variable the value of the sheet name?" A. In the source sheet code, I used: Public Sourcesheet As String Private Sub cmdBut_Wk0_Click() Sourcesheet = ActiveSheet.Name etc etc End sub This picks up the sheetname OK as, MsgBox "Sourcesheet...

Thanks Skip for the pointer on Scope (will read between posts) PHV, Have removed that line of code. I now have... Private Sub cmdBut_Return_to_Source_Click() MsgBox "Sourcesheet is : " & Sourcesheet 'Return to original source sheet... Sheets(Sourcesheet).Select etc etc End sub Still get a...

Thanks again nnet, In the calculation sheet I have ... Private Sub cmdBut_Return_to_Source_Click() Dim Sourcesheet as String MsgBox "Sourcesheet is : " & Sourcesheet 'Return to original source sheet... Sheets(Sourcesheet).Select etc etc End sub ... but this results in MsgBox showing Null...

Thanks nnet Do you mean like this? private sub fred_click() Sourcesheet = ActiveSheet.Name etc etc Public Sourcesheet As String End sub I get a compile error "Invalid attribute in sub or function"

?! How do I use Application.Caller to remember the previous sheet name?

When I click a button on sheet wk0, I go to a calc sheet where I eventually click a submit button to return to the original sheet (Wk0) and cell, setting the calculated value in the cell. This works OK with a single sheet because I hard code the sheetname (Wk0) for the return path, but I now...

That's handy. Cheers, combo. Your help much appreciated. * BTW: Where/how does one discover these seemingly hidden control codes?

Here is the output from the macro recorder ( plus my comments):- Sheets("Lookups").Select 'This sheet has the 3 lists on it, in columns B, D and F. Range("F3").Select 'This is where the third list starts ActiveSheet.ShowDataForm 'This causes the form to open and allows me to add a new...

I have an excel spreadsheet which contains 3 lists on the same page, side by side. I have selected any one of the lists and clicked on Data ... Form .. and I am able to add or delete entries in the correctly selected list. I want to be able to just click on one of 3 buttons (one per list) and...