MinhTech.com

Yet another technology tutorial blog.

Archives for the ‘Office’ Category

Excel VBA Unable to set the Visible property of the PivotItem class

By • Aug 7th, 2010 • Category: Office

Chances are AutoSort is enabled if you are getting this error message.



Excel Validation with Dropdown Lists

By • Mar 1st, 2009 • Category: Office

Here is how to setup Excel dropdown lists to improve data integrity during data entry.