0713910067's blog

Fed up of seeing excel opening screen

As i open excel 2010 workbook, it opens a small window in yellow colour , which means that excel is starting.

I am fed up of seeing this screen.

For my few workbooks, I want my own screen to display as Excel starts up rather than excel start up window.

How can I do this.

Any help would be appreciable.

Thanks in Advance...

Get data of bottom 5 customer but greater than 0

How can i get get data of bottom 5 customer but greater than 0 through VBA.

Need help

how to use skype class and gtalk class available in excel 2010

Can anybody tell me how can we use skype class and gtalk class available in excel 2010.

Thanks in advance.
Any help'll be appreciated.

Please help..

change icon

I want to change the icon showing in the left top most of the excel to my own icon.
Can anybody help me for the same.

hide / unhide tab

How can we hide tabs (such as home, insert etc) in excel through VBA automatically .

refresh data in power pivot automatically without the use of share point

can anybody tell me how to refresh data in power pivot automatically without the use of share point

how to crack password of excel

1) Can anybody tell me that how can we crack password of vba in excel.

2) Can anybody tell me how to unprotect sheet, even though i have lost my password.

How to open excel file with .xlsb extension in our android mobile or tab.

Dear Friends.

Can anybody tell me that how can we open an excel file with .xlsb extension in our android mobile and tablet.

I downloaded some softwares but couldn't open .xlsb file.
Can anybody help me out with solution.

data type of textbox in excel

1) How can we set data type of text box to number in excel so that it always accepts number only and if user inputs character then it'll not accept it.

2) How can we set not null to a text box so that textbox would become mandetory..

Freeze shapes in excel

Is there any way to freeze a shape in certain place.

That means,when we make a shape(rectangle) in our excel sheet and then when we scroll up/down or left/right sheet moves accordingly but shape will not move.
It will retain the same place.

Please check for new sheet.

insert sheet within sheet

How can we add sheet within sheet.

For eg: If I am having sheet1 in my workbook and now I want to show another sheet within sheet1, then how can we do this.

scroll bar within excel sheet

How can we make scroll bar (horizontal and vertical )within excel sheet so that we can restrict an area where data can be shown.

Here I am attaching a file through which we all can get as an idea , what exactly I want.

As in this sheet1 red border is showing area for total data.
Green Border is showing the area within which we want to show data of this pivot table.
This means that there should be scroll bar after green border
So how should I do this.

Regarding click event of charts

I am attaching a file which contains two sheets named as metadata and report.
I have made two charts on it , now when I select any region on graph1 then customers related to that particular region must be shown in graph2.

I want to use region graph for filtration process.

Syndicate content