0713910067's blog
Fed up of seeing excel opening screen
Submitted by 0713910067 on 3 September, 2013 - 20:28As 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
Submitted by 0713910067 on 12 April, 2013 - 08:28How can i get get data of bottom 5 customer but greater than 0 through VBA.
Need help
- 1 comment
- 3580 reads
how to use skype class and gtalk class available in excel 2010
Submitted by 0713910067 on 28 February, 2013 - 08:35Can 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
Submitted by 0713910067 on 5 January, 2013 - 08:41I 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
Submitted by 0713910067 on 22 October, 2012 - 05:15How can we hide tabs (such as home, insert etc) in excel through VBA automatically .
- 1 comment
- 3000 reads
refresh data in power pivot automatically without the use of share point
Submitted by 0713910067 on 21 September, 2012 - 11:01can anybody tell me how to refresh data in power pivot automatically without the use of share point
- 1 comment
- 3982 reads
how to crack password of excel
Submitted by 0713910067 on 21 September, 2012 - 04:491) 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.
- 1 comment
- 4297 reads
How to open excel file with .xlsb extension in our android mobile or tab.
Submitted by 0713910067 on 18 September, 2012 - 09:15Dear 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.
- 1 comment
- 19316 reads
data type of textbox in excel
Submitted by 0713910067 on 10 September, 2012 - 10:461) 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..
- 1 comment
- 7526 reads
Freeze shapes in excel
Submitted by 0713910067 on 18 August, 2012 - 08:10Is 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.
- 10 comments
- 35805 reads
insert sheet within sheet
Submitted by 0713910067 on 17 August, 2012 - 06:43How 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.
- 4 comments
- 25133 reads
scroll bar within excel sheet
Submitted by 0713910067 on 17 August, 2012 - 05:38How 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.
- 3 comments
- 11775 reads
Regarding click event of charts
Submitted by 0713910067 on 13 August, 2012 - 06:47I 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.
- 1 comment
- 2640 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago