Recent content by calvinb

Thank you, Combo! That works fine. Much appreciated!!

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 have it on flat now but it's not very noticeable!! Just a tiny checkmark in the middle of a square box. Thanks for the suggestion though.

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

Thanks for you quick answer!! I'll give it a try tomorrow at work. I appreciate the help.

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 crossposting this to MrExcel forum.

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 want to do it with coding. Thanks for your suggestion though.