Search results for query: *

Thanks Venkman - didn't know it existed... easier than SendKeys...

I now think I can do it with SendKeys... Application.SendKeys ("%T") Application.SendKeys ("P") Application.SendKeys ("P") Application.SendKeys ("abc~") Application.SendKeys ("abc~")

Hi - I have a workbook ("Template") which creates quotes in a separate workbook ("Quote"). The Quote workbook is created new every time - I built it this way so that customers wouldn't receive quotes with macros attached. I've been able to lock the Quote workbook, but have...

How about using Comments? Add the Comment, right click and select Show Comment. On the Page Setup, under Print, Sheet, just make sure the selection for Comments is <None>. You can now make them look nice on screen and not have them print. Kadam.

Hi - I've created many spreadsheets for others to use around the corp (all XL2000), and some users have complained that the drop down arrows don't appear where I have cell validation. I've actually see one user's computer where the arrows were there, but TINY. Now on my computer I can't seem to...

Found a response to this on deja.com ... there is a utility called Chart Labeller at www.appspro.com ... solved the problem. Kevin.

Hi - having problems getting Excel to label my data points how I want them... A sample data set: Rep Hopping Jumping John 4 7 Kevin 2 8 Carl 5 12 Lenny 1 3 What we're trying to do is create a scatterplot that shows a single point for...

Hi - make sure Macro Virus protection is turned on. You could also try changing the default file location and seeing if that has any effect. Kevin.

A couple of years back I was designing a database and had to make the choice between Access and Excel. I chose Excel because at the time I was an Access novice and Excel is much more intuitive, even when coding. I should have used Access, however, because Excel has a limit on table size to...

Hi - I encountered this the other day, and no information could be found at Microsoft. My situation: DB on network drive, used constantly by two users. A few days ago, they came in in the morning and tried to open the DB and received the &quot;Unexpected Error: 35012&quot;. The switchboard...

Hi - two ideas off the top of my head... 1) Have track changes on, and highlight changes on screen. Have a cell where the person has to add their name for sign off. Track Changes records the name of the person who signed off, and when. 2) Have a macro that verifies the user by checking the...

Hi - why don't you just copy the entire cell, and then do a Find (&quot; &quot;) and Replace (&quot;&quot;) to get rid of all the spaces. Another way to find and move all cells that begin with a space is to use Text to Columns (or a macro recording text to columns) that has the space as the...

I've checked all of my queries, and all are set to 'no locks'. The .ldb file seems to be working as it should and deletes itself after users exit. The other thing that I've heard about is the system.mdw file. My users are using their own system.mdw file and are not connected to a workgroup...

I'm getting the same problem but have yet to find an answer. I've got an Access 97 database on a network drive and is accessed by usually two users. One of the two often gets &quot;Out of Memory&quot; and then a message that the database is locked by the other user. The same problem exists on...