Thanks Combo. That works exactly like I wanted. I have one co-worker who doesn't like it so I was wondering if there is a way to turn it on and off... say with a checkbox or button. I tried today with an existing checkbox on the page but couldn't get it to work.
Thanks Skip. I'll check that out!
Yeah, I think it's the printer drivers also but my computer is fine. It prints on one page but a couple of my co-workers seem to have different drivers and it doesn't work for them. I'm not allowed to change the drivers so they have just moved the right border on the sheet until it all fits and...
I use Excel 2010 and the forms Checkboxes. When I print the sheet the checks in the checkboxes are difficult to see. They are too light and tiny. Is there a way to make the checks in checkboxes darker or larger?
Thanks.
I have an Excel 2010 sheet with a lot of checkboxes on each row. The user has to type some info in the left side and then move across the row to check some of the checkboxes. The problem is that it's easy to get up or down a row and therefore check the checkbox on the wrong row.
I would like...
Ok. I tried that code at work but it still didn't print everything on one page. It still printed about a half inch of the right column on a second page and the bottom row on another page.
The two computers that are causing this problem seem to be different than other computers at work. That...
I have a form in Excel 2010 that my coworkers and I have to print doing our job. I use the following code to print the form:
Sheets("ControlSheet").PrintOut
When I print the form, it prints fine but when some of my co-workers print it, it doesn't fit on one page. It actually takes 4 pages to...
Larena:
Thanks for the suggestions but I have tried on different printers here and at work but there is no difference. The odd thing is that it used to work on all the printers and I haven't changed the borders but it just stopped printing parts of them.
ColinMitton:
Thank you also for your...
Forms.
I'm using a heavier line now. The borders are all there but it looks terrible because they are so dark!! And around the checkboxes part of the borders are missing so the checkboxes definitely have something to do with this problem.
I have a form in Excel 2010 that has borders around many of the cells. I used the fine dotted line because the solid line prints out too dark. This was fine for 2 weeks but yesterday, when I printed the form, parts of the borders are missing. There doesn't seem to be any reasoning to it, just...
I'm not getting anywhere with this!!
I did the record macro thing and here is the results:
Sub Macro4()
'
' Macro4 Macro
'
Sheets("Import").Select
Range("C4:I13").Select
Selection.Copy
Sheets("Data").Select
Range("C4").Select
ActiveSheet.Paste...
I have a worksheet with 7 columns (C to I). I paste a large table from the internet into these columns and some of them are duplicates.
I would like to be able to run a macro to find the duplicate cells (in Column C) and move the duplicate rows (including the original row) from Columns C to I...
Ok, I did it manually!! It took all afternoon but I entered the option buttons in individual groupboxes for each row and each group and it is all working fine.
Thanks for your efforts, Skip!
PS I still want to be able to find duplicate entrys and move them to the beginning of the list using...
Thanks Skip!
I removed the other lines and just left 3 for demonstration purposes.
The way this works is that we have a table of information online that I copy and paste on the sheet called "Import". (I would like to then check that for duplicates and have them move to the top rows as...
Thanks Skip. Here is the code I get when I create an option button and a group:
Sub Macro1()
'
' Macro1 This is the default sizes when I added an option button and a group.
'
'
ActiveSheet.OptionButtons.Add(370.5, 32.25, 72, 72).Select
ActiveSheet.GroupBoxes.Add(478.5, 34.5, 72...
I need to create many mutually exclusive option buttons and it's very difficult and time consuming doing it by hand!
I have 20 rows where I need a group of 3 in columns J4:L4, then a group of 2 in columns M4:N4, then another group of 3 in columns O4:Q4 and finally a group of 2 in columns U4:V4...
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.