Recent content by Thwarted

Thanks Skip I will give it a shot!

Thanks Skip I am ok activating the one sheet Set CurrentSheet = Sheets("P2 - Summary") CurrentSheet.Activate I just dont know how to add a button or checkbox or something that the user can click to undo this: For Each cb In PrintDlg.CheckBoxes Select Case cb.Text...

Hi Had this in the wrong forum originally - sorry! I'm using the select sheets to print code from: http://j-walk.com/ss/excel/tips/tip48.htm (code pasted below) it is working well. I have also added a bit more code to pre-select some of the sheets, however, I need to add in another option...

Hi I'm using the select sheets to print code from: http://j-walk.com/ss/excel/tips/tip48.htm (code pasted below) it is working well. I have also added a bit more code to pre-select some of the sheets, however, I need to add in another option to clear all for the off chance they do not need...

Hi Skip I am answering a question from a long time ago - I had left this as it was working but now have some time to clean it up. I am not sure how to do what you described with the table - but that sounds like it would be much cleaner! I have multiple sheets that each have combo boxes. Is...

Thanks guys! The GetSaveAsFileName method worked great!

Hi I have searched Save As and do not see this question though I am sure it had to have been asked and answered so I am sorry for the repeat if it does exist. I need to code my Excel sheet to Save As where i provide a filename based on contents of a cell - but I allow them to choose the path...

Here is what I ended up with I cant take credit a friend of mine sent me similar code that i could make fit what i needed. Sub ComboBox4_KeyDown(ByVal _ KeyCode As MSForms.ReturnInteger, _ ByVal Shift As Integer) Select Case KeyCode Case 9 'Tab...

woohoo! I figured how to do it with code Thanks!

I have a combobox in Excel - well a few of them and i want to be able to tab from one to the next or to the next cell

this could be a dumb question but how to you set a combo box so you can tab - or even enter from it? Thanks!!

Hi Judy Thank you - that does work! I think now i will just have to put something in BeforeClose so that it will remove the toolbar from the application (so it is not showing up on other workbooks). Hoping it will stick to the workbook though after i do that!

Thank you!!

Hi I posted this on the wrong forum but Skip was kind enough to help me out - the only thing is - where do i put the code for adding and removing the toolbar OnOpen and OnClose ?? (do those exist)? Thank you!! (original post and answer below) Hi Is there a way to add a toolbar to a...

Hi Is there a way to add a toolbar to a workbook that will be shared? I am creating a template and want the toolbar to stick with the workbook every time it is saved as a new file. I addd the toolbar and it works great on my hard drive and as long as i dont rename the file. Any advice...